﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_DispatcherMode') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_DispatcherMode
END
GO
create view V_DispatcherMode
as select 
A.[Guid]
,A.[Formula]
,A.[SafeCost]
,A.[DispatchType]
from [ShopNum1_DispatchMode] A where A.IsDeleted=0